Microsoft SQL Server

The following table maps the ODBC data types that the ODBC driver supports to the Microsoft SQL Server:

Table B-3. Mapping Data Types for Microsoft SQL Server to ODBC Data Types 

Microsoft SQL Server 2000, 2005 Data Type	ODBC Data Type
bigint	SQL_BIGINT
bigint identity	SQL_BIGINT
binary	SQL_BINARY
bit	SQL_BIT
char	SQL_CHAR1 SQL_WCHAR2
datetime	SQL_DATETIME3 SQL_CHAR4
decimal	SQL_DECIMAL
decimal identity	SQL_DECIMAL
float	SQL_FLOAT
guid	SQL_BINARY
image	SQL_LONGVARBINARY
int	SQL_INTEGER
int identity	SQL_INTEGER
money	SQL_DECIMAL
nchar	SQL_CHAR1 SQL_WCHAR2
ntext	SQL_LONGVARCHAR1 SQL_WLONGVARCHAR2
nvarchar(max)	SQL_LONGVARCHAR
numeric	SQL_NUMERIC
numeric identity	SQL_NUMERIC
nvarchar	SQL_VARCHAR1 SQL_WVARCHAR2
real	SQL_REAL
smalldatetime	SQL_DATETIME3 SQL_CHAR4
smallint	SQL_SMALLINT
smallint identity	SQL_SMALLINT
smallmoney	SQL_DECIMAL
SQLVariant	SQL_BINARY
sysname	SQL_VARCHAR1 SQL_WVARCHAR2
text	SQL_LONGVARCHAR1 SQL_WVARCHAR2
timestamp	SQL_BINARY
tinyint	SQL_TINYINT
tinyint identity	SQL_TINYINT
uniqueidentifier	SQL_BINARY
varbinary	SQL_VARBINARY
varbinary(max)	SQL_LONGVARBINARY
varchar	SQL_VARCHAR1 SQL_WVARCHAR2
varchar(max)	SQL_LONGVARCHAR1

1Not present when DataSourceReportChar=False and ServiceCodePage=Database 2Only present whe ServiceCodePage=Database 3Only present when DataSourceFetchTimestampAsString=False 4Only present when DataSourceFetchTimestampAsString=True